By clause
英 [baɪ klɔːz]
美 [baɪ klɔːz]
网络 By子句
双语例句
- I read their written contracts, clause by clause; to be sure nothing had been omitted from the oral agreement.
然后我一条一条地读了他们的书面合同，确信没有从口头协议中漏掉什么。 - All of the SQL expressions for any attributes that were selected as columns in the SELECT clause should also be in the GROUP BY clause.
对于作为SELECT子句中的列的任何属性，它们的SQL表达式也应该放在GROUPBY子句中。 - The clauses of the query such as its selection terms, the selection predicate in a WHERE clause, and ordering terms in an ORDER BY clause can all be mutated.
可以改变查询的子句，比如它的选择条件、WHERE子句中的选择谓词和ORDERBY子句中的排序条件。 - For all rows produced by the iterations of the CONNECT BY clause LEVEL is raised by1.
对于通过CONNECTBY子句的迭代生成的所有行，LEVEL增加1。 - The index on the outermost table can be used to return rows in the order of the ORDER BY clause, eliminating the need for a sort.
可以用最外面的表上的索引，以ORDERBY子句的次序返回行，从而消除排序的需要。 - For example, you may want to change the SQL to take advantage of a newly added index, to limit the number of rows returned, or to add a sorely needed ORDER BY clause.
例如，您可能想更改SQL，以利用新添加的索引，或者限制返回的行数，又或者添加非常需要的orderby子句。 - I also described two ways to use the PARTITION BY clause of the CREATE TABLE statement to create partitioned tables.
我还描述了使用CREATETABLE的PARTITIONBY子句来创建分区表的两种方法。 - Tables must be created with the DISTRIBUTE BY HASH clause of the CREATE TABLE statement.
在创建表时，必须在CREATETABLE语句中使用DISTRIBUTEBYHASH子句。 - Like in a regular ORDER BY clause multiple columns can be specified in either ascending or descending sequence.
类似于在常规的ORDERBY子句中，可以按升序或降序指定多个列。 - Because the starting point is not checked for cyclic data and'Frankfurt'must not be connected again, it is eliminated in the CONNECT BY clause ( Arrival'Frankfurt ').
因为没有检查循环数据的起始点，并且不能再次连接到“法兰克福市”，所以将从CONNECTBY子句中删除该中转（Arrival'Frankfurt'）。 - Adding an ORDER SIBLINGS BY clause which is only allowed in composition with the hierarchical query clause and will return the siblings in the predefined sequence.
添加一个ORDERSIBLINGSBY子句，该子句只能与分级查询子句组合使用，并且将按预先定义的顺序返回同级查询结果。 - The row order in the query elements table in which columns are defined determines their left to right sequence within the ORDER BY clause, which in turn determines their sorting priority.
定义了列的查询元素表中的行顺序决定了它们在ORDERBY子句中从左到右的顺序，这又确定了它们的排序优先级。 - Table data is partitioned as specified in the PARTITION BY clause of the CREATE TABLE statement.
CREATETABLE语句的PARTITIONBY子句指定了表数据的分区。 - The specifications provided in the PARTITION BY clause of the CREATE TABLE statement define how data in a table is partitioned.
CREATETABLE语句的PARTITIONBY子句中提供的信息决定表数据的分区方式。 - They can be simple, UNION, or joined sub-queries, including OUTER joins, and can include the ORDER BY clause.
它们可以是简单子查询、UNION或连接（包括OUTER连接）子查询，并且可以包括ORDERBY子句。 - If you add an ORDER BY clause, to order by the extracted city value, the result set still remains the same: PARIS, paris, and Paris are treated as the same value.
如果通过添加ORDERBY子句按提取的city值排序，那么结果集仍然是相同的：PARIS、paris和Paris被当作相同的值。 - Next, ensure that the index has these columns in the proper sequence ( according to the ORDER BY clause), so that a sort can be avoided.
接下来，确保索引中这些列有适当的顺序（按照ORDERBY子句），这样可以避免排序。 - To avoid unpredictable output in this situation, we would need to code the ORDER BY clause ( even before DB29).
要避免在此情形下出现无法预期的输出，我们将需要编写ORDERBY子句（甚至在DB29之前）。 - The temporarily created field SORT is used within the ORDER BY clause, to get the result returned in the depth-first sequence.
临时创建的字段SORT用于ORDERBY子句内，以便按深度优先顺序获得返回的结果。 - Note that an ORDER BY clause in the SELECT statement would not have any effect on the order of the array elements, as it would apply to the rows returned by the statement.
请注意，SELECT语句中的orderby子句不会对阵列元素的顺序产生任何影响，因为它将应用于该语句返回的行。 - The pseudo column LEVEL can be used in the ORDER BY clause to return the result set in search breadth first sequence.
可在ORDERBY子句中使用伪列LEVEL按照搜索宽度优先顺序返回结果集。 - The attributes appear in both the SELECT clause and the GROUP BY clause.
这些属性出现在SELECT子句和GROUPBY子句中。 - The partitioning key should be made up of columns that often participate in a GROUP BY clause.
分区键应该由常用于GROUPBY子句的列组成。 - These operator choices provide further sorting control and accompany a given column in the ORDER BY clause.
这些操作符选择提供进一步的排序控制，伴随着ORDERBY子句中的给定列出现。 - This requirement to add an ORDER BY clause in addition to the GROUP BY clause is new with the RANDOM option.
这种除GROUPBY子句外还要添加ORDERBY子句的需求是RANDOM选项中新增的功能。 - Aggregate functions are usually used with a GROUP BY clause.
合计功能通常与GROUPBY子句配合使用。 - All columns in the SELECT list that are not in group functions must be in the GROUP BY clause.
凡是出现在查询列表中的没有应用分组函数的字段必须要出现在GROUPBY子句中，否则报错。 - The ORDER BY clause is specified when you retrieve data from the view.
ORDERBY子句只有当你检索数据的时候才被指定。 - This paper presents the principle of interaction between the rights and liabilities in construction engineering contracts, which is also used to make a comparison between and analysis, clause by clause with the tabulation method, of the right and liability clauses commonly seen in engineering contracts.
提出了建筑工程承包合同中的权利与责任条款的相互制约原则，并运用这一原则对工程承包合同中常见的权利和责任条款逐条列表进行对比分析。 - There are many computations about the aggregation function in the data warehouse, and the most time-consuming part is to execute the GROUP BY clause, which can be implemented by sorting in general.
数据仓库用聚集函数计算决策所需要的总结数据，计算聚集函数最费时的部分是执行GroupBy子句，一般用排序方法实现。